Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PromotionalInitiativeID (PK) | A token ID for a retailer's PromotionInitiative instance. | ID_PRML_INITV | Identity | integer | |
PromotionInitiativeName | A business name for the promotion initiative. | NM_PRML_INITV | DescriptionShort | varchar(255) | |
PromotionNarrative | A short narrative description of the promotion initative that explains its purpose, a high level view of how it works and other infromation to help business users understand it. | NA_PRML_INITV | DescriptionNarrative | varchar(4000) | |
PromotionInitiativeEffectiveDateTime | Date and time a promotional initiative starts | DT_EF | EffectiveDateTime | datetime | |
PromotionalInitiativeExpirationDateTime | Date and time a promotion initiative ends | DT_EP | ExpirationDateTime | datetime | |
StatusCode | The status of this PromotionInitiative instance. Sample values: A = Active i = Inactive P = Pending (for promotion initiatives to be launched in the future) | CD_STS | Code2Status | char(2) | |
PromotionInitiativeTypeCode (FK) | Defines a specific category of promotion initiative. See PromotionInitiativeType entity definition for a list of examples. | CD_PRML_TYP | Code | varchar(20) | PromotionInitiativeType(LU_PRML_INIT_TYP) |
CampaignPromotionID (FK) | Token ID for a CampaignPromotion. This represents the unique identifier for a PROMOTION which is taking place within the context of a campaign. | ID_CMPGN_PRM | Identity | integer | CampaignPromotion(CO_CMPGN_PRM) |
AdvertisementID | A reference to the advertisement associated with this PromotionInitiative. | ID_ADVTSMT | Identity | integer | |
CatalogID | Reference to the catalog this promotion is part of. | ID_CTLG | Identity | integer | |
OccasionName (FK) | The name ofr the Holiday instance | NM_HLDY | Name | varchar(40) | Holiday(CO_HLDY) |